Back to Main Menu

SQL Server Analysis Services (Optional)

SSAS Introduction

This section provides additional information for setting up SQL Server Analysis Services for reporting in myData.

 

This option can greatly improve the speed of generating AFR. 

Install SSAS feature for SQL Server Standard

Ensure SQL Analysis services has been installed on the server, if not this can be added to an existing installation noting that feature Analysis Services is checked during the install process

Setup new databases using SQL management studio

A database needs to be setup on the Analysis server and a reports datasource on the Database engine.

  • OLAP database on SQL Analysis Services i.e. called myDataProdReport
  • OLAP datasource on SQL Database engine i.e. called myDataProdRDS*
  • (both OLAP database and datasource must be on the same SQL server)

*RDS = Report Data Source

Setup user permissions

 

Setup the user management as per the below table

  • NT AUTHORITY\NETWORK SERVICE needs read only access to the report database i.e. myDataProdRDS

    Type

    Database 
    Name (SQL)

    Reporting Data Source (SQL)

    Reporting 
    Database (SSAS)

    Databases

    myDataProduction

    myDataProdReportRDS

    myDataProdReport

    myDataPreProduction

    myDataPreProdReportRDS

    myDataPreProdReport

    USER 
    Permissions

    db_owner

    db_owner

    SSAS Server Admin

    NETWORK SERVICE 
    Permissions

    None

    db_datareader

    None

Verify the account used to access the SQL Server Analysis Service can connect to the SSAS server from the machine running myData application. 

Install OLAP tables using myData admin utility

Using the myData admin utility setup the table structure for SSAS reporting

  • OLAP needs to be configured for the Production and PreProduction databases as a minimum (Separate config files)
  • OLAP Server uses windows authentication only

         

Run AFR Reports in myData

When running Annual Financial Reports through myData/myValuer they will now use the SSAS reporting engine and can be saved after the report has been generated.

  • Generated reports can now be saved
  • Any saved report can be viewed instantly


Ongoing maintenance

Any unsaved reports will currently remain in the reporting datasource, however they will not be visible to myData/myValuer users. It is recommended to purge these reports periodically

  • myData/Tools/Compact and Repair Reports
  • Removes unsaved report data